﻿-- Creating table 'LogAppointments'
-- Creating table 'LogAppointments'
-- Creating table 'LogAppointments'
-- Creating table 'LogAppointments'
-- Creating table 'LogAppointments'
CREATE TABLE [dbo].[LogAppointments] (
    [LogAppointmentID] int IDENTITY(1,1) NOT NULL,
    [EmployeeCode] nvarchar(5)  NOT NULL,
    [LogDateTime] datetime  NOT NULL,
    [Action] int  NOT NULL,
    [PostponeRemark] nvarchar(255)  NULL,
    [AppointmentID] int  NOT NULL
);














